package team.ttorder.ttorder.dao;

import java.util.List;

import org.apache.ibatis.annotations.Select;

import team.ttorder.ttorder.model.Food;
import team.ttorder.ttorder.model.Table;
import team.ttorder.ttorder.mymapper.MyMapper;

public interface TableMapper extends MyMapper<Table>{
	
	@Select("SELECT id as id,table_name as tableName,tables_status as tablesStatus,order_date as orderDate FROM dinner_table WHERE tables_status = #{TablesStatus}")
	public List<Table> selectTablesStatus(int TablesStatus);
	
	@Select("SELECT id as id,food_name as foodName,price as price,img as image ,m_price as mPrice FROM food WHERE food_type_id = #{foodTypeId}")
	public List<Food> selectFoot(int foodTypeId);

}
